Pandas Profiling Report

Dataset statistics

Number of variables	34
Number of observations	72983
Missing cells	149203
Missing cells (%)	6.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	18.9 MiB
Average record size in memory	272.0 B

Variable types

Numeric	16
Categorical	17
Boolean	1

Warnings

`PurchDate` has a high cardinality: 517 distinct values	High cardinality
`Model` has a high cardinality: 1063 distinct values	High cardinality
`Trim` has a high cardinality: 134 distinct values	High cardinality
`SubModel` has a high cardinality: 863 distinct values	High cardinality
`VehYear` is highly correlated with `VehicleAge` and 8 other fields	High correlation
`VehicleAge` is highly correlated with `VehYear` and 5 other fields	High correlation
`MMRAcquisitionAuctionAveragePrice` is highly correlated with `VehYear` and 9 other fields	High correlation
`MMRAcquisitionAuctionCleanPrice` is highly correlated with `VehYear` and 9 other fields	High correlation
`MMRAcquisitionRetailAveragePrice` is highly correlated with `VehYear` and 8 other fields	High correlation
`MMRAcquisitonRetailCleanPrice` is highly correlated with `VehYear` and 8 other fields	High correlation
`MMRCurrentAuctionAveragePrice` is highly correlated with `VehYear` and 9 other fields	High correlation
`MMRCurrentAuctionCleanPrice` is highly correlated with `VehYear` and 9 other fields	High correlation
`MMRCurrentRetailAveragePrice` is highly correlated with `VehYear` and 9 other fields	High correlation
`MMRCurrentRetailCleanPrice` is highly correlated with `VehYear` and 8 other fields	High correlation
`VehBCost` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 7 other fields	High correlation
`VehYear` is highly correlated with `VehicleAge` and 8 other fields	High correlation
`VehicleAge` is highly correlated with `VehYear` and 5 other fields	High correlation
`MMRAcquisitionAuctionAveragePrice` is highly correlated with `VehYear` and 9 other fields	High correlation
`MMRAcquisitionAuctionCleanPrice` is highly correlated with `VehYear` and 9 other fields	High correlation
`MMRAcquisitionRetailAveragePrice` is highly correlated with `VehYear` and 8 other fields	High correlation
`MMRAcquisitonRetailCleanPrice` is highly correlated with `VehYear` and 8 other fields	High correlation
`MMRCurrentAuctionAveragePrice` is highly correlated with `VehYear` and 9 other fields	High correlation
`MMRCurrentAuctionCleanPrice` is highly correlated with `VehYear` and 9 other fields	High correlation
`MMRCurrentRetailAveragePrice` is highly correlated with `VehYear` and 9 other fields	High correlation
`MMRCurrentRetailCleanPrice` is highly correlated with `VehYear` and 8 other fields	High correlation
`VehBCost` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 7 other fields	High correlation
`VehYear` is highly correlated with `VehicleAge`	High correlation
`VehicleAge` is highly correlated with `VehYear`	High correlation
`MMRAcquisitionAuctionAveragePrice` is highly correlated with `MMRAcquisitionAuctionCleanPrice` and 7 other fields	High correlation
`MMRAcquisitionAuctionCleanPrice` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 7 other fields	High correlation
`MMRAcquisitionRetailAveragePrice` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 7 other fields	High correlation
`MMRAcquisitonRetailCleanPrice` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 7 other fields	High correlation
`MMRCurrentAuctionAveragePrice` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 7 other fields	High correlation
`MMRCurrentAuctionCleanPrice` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 7 other fields	High correlation
`MMRCurrentRetailAveragePrice` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 7 other fields	High correlation
`MMRCurrentRetailCleanPrice` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 7 other fields	High correlation
`VehBCost` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 7 other fields	High correlation
`MMRAcquisitionAuctionAveragePrice` is highly correlated with `MMRAcquisitionRetailAveragePrice` and 8 other fields	High correlation
`MMRAcquisitionRetailAveragePrice` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 7 other fields	High correlation
`MMRAcquisitionAuctionCleanPrice` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 8 other fields	High correlation
`Nationality` is highly correlated with `Make` and 1 other fields	High correlation
`Make` is highly correlated with `Nationality` and 3 other fields	High correlation
`TopThreeAmericanName` is highly correlated with `Nationality` and 2 other fields	High correlation
`MMRCurrentRetailCleanPrice` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 7 other fields	High correlation
`MMRCurrentAuctionAveragePrice` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 9 other fields	High correlation
`BYRNO` is highly correlated with `VehicleAge` and 3 other fields	High correlation
`Size` is highly correlated with `Make` and 3 other fields	High correlation
`Auction` is highly correlated with `RefId` and 1 other fields	High correlation
`VehicleAge` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 6 other fields	High correlation
`MMRAcquisitonRetailCleanPrice` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 7 other fields	High correlation
`RefId` is highly correlated with `BYRNO` and 3 other fields	High correlation
`MMRCurrentAuctionCleanPrice` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 8 other fields	High correlation
`MMRCurrentRetailAveragePrice` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 8 other fields	High correlation
`WheelType` is highly correlated with `Size` and 1 other fields	High correlation
`PRIMEUNIT` is highly correlated with `MMRCurrentAuctionAveragePrice` and 1 other fields	High correlation
`VNST` is highly correlated with `BYRNO` and 3 other fields	High correlation
`WheelTypeID` is highly correlated with `WheelType`	High correlation
`VehBCost` is highly correlated with `MMRAcquisitionAuctionAveragePrice` and 8 other fields	High correlation
`VNZIP1` is highly correlated with `BYRNO` and 2 other fields	High correlation
`VehYear` is highly correlated with `VehicleAge`	High correlation
`WarrantyCost` is highly correlated with `Make` and 1 other fields	High correlation
`Nationality` is highly correlated with `Make` and 1 other fields	High correlation
`Make` is highly correlated with `Nationality` and 1 other fields	High correlation
`WheelType` is highly correlated with `WheelTypeID`	High correlation
`TopThreeAmericanName` is highly correlated with `Nationality` and 1 other fields	High correlation
`VNST` is highly correlated with `Auction`	High correlation
`WheelTypeID` is highly correlated with `WheelType`	High correlation
`Auction` is highly correlated with `VNST`	High correlation
`Trim` has 2360 (3.2%) missing values	Missing
`WheelTypeID` has 3169 (4.3%) missing values	Missing
`WheelType` has 3174 (4.3%) missing values	Missing
`PRIMEUNIT` has 69564 (95.3%) missing values	Missing
`AUCGUART` has 69564 (95.3%) missing values	Missing
`RefId` is uniformly distributed	Uniform
`RefId` has unique values	Unique
`MMRAcquisitionAuctionAveragePrice` has 828 (1.1%) zeros	Zeros
`MMRAcquisitionRetailAveragePrice` has 828 (1.1%) zeros	Zeros
`MMRAcquisitonRetailCleanPrice` has 828 (1.1%) zeros	Zeros

Reproduction

Analysis started	2021-06-06 16:57:14.921285
Analysis finished	2021-06-06 16:58:47.768918
Duration	1 minute and 32.85 seconds
Software version	pandas-profiling v3.0.0
Download configuration	config.json

RefId
Real number (ℝ_≥0)

HIGH CORRELATION
UNIFORM
UNIQUE

Distinct	72983
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	36511.4285

Minimum	1
Maximum	73014
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	1
5-th percentile	3652.1
Q1	18257.5
median	36514
Q3	54764.5
95-th percentile	69364.9
Maximum	73014
Range	73013
Interquartile range (IQR)	36507

Descriptive statistics

Standard deviation	21077.2413
Coefficient of variation (CV)	0.5772779146
Kurtosis	-1.199960415
Mean	36511.4285
Median Absolute Deviation (MAD)	18254
Skewness	-0.000203080177
Sum	2664713586
Variance	444250100.9
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2047	1	< 0.1%
10896	1	< 0.1%
64138	1	< 0.1%
62091	1	< 0.1%
51852	1	< 0.1%
49805	1	< 0.1%
55950	1	< 0.1%
53903	1	< 0.1%
8849	1	< 0.1%
60040	1	< 0.1%
Other values (72973)	72973	> 99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
2	1	< 0.1%
3	1	< 0.1%
4	1	< 0.1%
5	1	< 0.1%
6	1	< 0.1%
7	1	< 0.1%
8	1	< 0.1%
9	1	< 0.1%
10	1	< 0.1%

Value	Count	Frequency (%)
73014	1	< 0.1%
73013	1	< 0.1%
73012	1	< 0.1%
73011	1	< 0.1%
73010	1	< 0.1%
73009	1	< 0.1%
73008	1	< 0.1%
73007	1	< 0.1%
73006	1	< 0.1%
73005	1	< 0.1%

IsBadBuy
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	570.3 KiB

0	64007
1	8976

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	72983
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	64007	87.7%
1	8976	12.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	64007	87.7%
1	8976	12.3%

Most occurring characters

Value	Count	Frequency (%)
0	64007	87.7%
1	8976	12.3%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	72983	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	64007	87.7%
1	8976	12.3%

Most occurring scripts

Value	Count	Frequency (%)
Common	72983	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	64007	87.7%
1	8976	12.3%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	72983	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	64007	87.7%
1	8976	12.3%

PurchDate
Categorical

HIGH CARDINALITY

Distinct	517
Distinct (%)	0.7%
Missing	0
Missing (%)	0.0%
Memory size	570.3 KiB

11/23/2010	384
2/25/2009	379
12/8/2010	372
8/26/2009	359
10/13/2010	359
Other values (512)	71130

Length

Max length	10
Median length	9
Mean length	8.981351822
Min length	8

Characters and Unicode

Total characters	655486
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	3 ?
Unique (%)	< 0.1%

Sample

1st row	12/7/2009
2nd row	12/7/2009
3rd row	12/7/2009
4th row	12/7/2009
5th row	12/7/2009

Common Values

Value	Count	Frequency (%)
11/23/2010	384	0.5%
2/25/2009	379	0.5%
12/8/2010	372	0.5%
8/26/2009	359	0.5%
10/13/2010	359	0.5%
2/18/2009	357	0.5%
11/3/2010	357	0.5%
11/17/2010	343	0.5%
1/21/2010	335	0.5%
10/20/2010	329	0.5%
Other values (507)	69409	95.1%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
11/23/2010	384	0.5%
2/25/2009	379	0.5%
12/8/2010	372	0.5%
8/26/2009	359	0.5%
10/13/2010	359	0.5%
2/18/2009	357	0.5%
11/3/2010	357	0.5%
11/17/2010	343	0.5%
1/21/2010	335	0.5%
10/20/2010	329	0.5%
Other values (507)	69409	95.1%

Most occurring characters

Value	Count	Frequency (%)
0	160392	24.5%
/	145966	22.3%
2	116587	17.8%
1	102214	15.6%
9	48424	7.4%
3	16371	2.5%
8	14074	2.1%
4	13254	2.0%
7	13123	2.0%
6	12715	1.9%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	509520	77.7%
Other Punctuation	145966	22.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	160392	31.5%
2	116587	22.9%
1	102214	20.1%
9	48424	9.5%
3	16371	3.2%
8	14074	2.8%
4	13254	2.6%
7	13123	2.6%
6	12715	2.5%
5	12366	2.4%

Other Punctuation

Value	Count	Frequency (%)
/	145966	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	655486	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	160392	24.5%
/	145966	22.3%
2	116587	17.8%
1	102214	15.6%
9	48424	7.4%
3	16371	2.5%
8	14074	2.1%
4	13254	2.0%
7	13123	2.0%
6	12715	1.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	655486	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	160392	24.5%
/	145966	22.3%
2	116587	17.8%
1	102214	15.6%
9	48424	7.4%
3	16371	2.5%
8	14074	2.1%
4	13254	2.0%
7	13123	2.0%
6	12715	1.9%

Auction
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	3
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	570.3 KiB

MANHEIM	41043
OTHER	17501
ADESA	14439

Length

Max length	7
Median length	7
Mean length	6.124727676
Min length	5

Characters and Unicode

Total characters	447001
Distinct characters	11
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	ADESA
2nd row	ADESA
3rd row	ADESA
4th row	ADESA
5th row	ADESA

Common Values

Value	Count	Frequency (%)
MANHEIM	41043	56.2%
OTHER	17501	24.0%
ADESA	14439	19.8%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
manheim	41043	56.2%
other	17501	24.0%
adesa	14439	19.8%

Most occurring characters

Value	Count	Frequency (%)
M	82086	18.4%
E	72983	16.3%
A	69921	15.6%
H	58544	13.1%
N	41043	9.2%
I	41043	9.2%
O	17501	3.9%
T	17501	3.9%
R	17501	3.9%
D	14439	3.2%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	447001	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
M	82086	18.4%
E	72983	16.3%
A	69921	15.6%
H	58544	13.1%
N	41043	9.2%
I	41043	9.2%
O	17501	3.9%
T	17501	3.9%
R	17501	3.9%
D	14439	3.2%

Most occurring scripts

Value	Count	Frequency (%)
Latin	447001	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
M	82086	18.4%
E	72983	16.3%
A	69921	15.6%
H	58544	13.1%
N	41043	9.2%
I	41043	9.2%
O	17501	3.9%
T	17501	3.9%
R	17501	3.9%
D	14439	3.2%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	447001	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
M	82086	18.4%
E	72983	16.3%
A	69921	15.6%
H	58544	13.1%
N	41043	9.2%
I	41043	9.2%
O	17501	3.9%
T	17501	3.9%
R	17501	3.9%
D	14439	3.2%

VehYear
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2005.343052

Minimum	2001
Maximum	2010
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	2001
5-th percentile	2002
Q1	2004
median	2005
Q3	2007
95-th percentile	2008
Maximum	2010
Range	9
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	1.731251606
Coefficient of variation (CV)	0.0008633194224
Kurtosis	-0.3258624512
Mean	2005.343052
Median Absolute Deviation (MAD)	1
Skewness	-0.337361228
Sum	146355952
Variance	2.997232123
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
2006	17043	23.4%
2005	15489	21.2%
2007	11423	15.7%
2004	10207	14.0%
2008	6885	9.4%
2003	6227	8.5%
2002	3405	4.7%
2001	1481	2.0%
2009	822	1.1%
2010	1	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2001	1481	2.0%
2002	3405	4.7%
2003	6227	8.5%
2004	10207	14.0%
2005	15489	21.2%
2006	17043	23.4%
2007	11423	15.7%
2008	6885	9.4%
2009	822	1.1%
2010	1	< 0.1%

Value	Count	Frequency (%)
2010	1	< 0.1%
2009	822	1.1%
2008	6885	9.4%
2007	11423	15.7%
2006	17043	23.4%
2005	15489	21.2%
2004	10207	14.0%
2003	6227	8.5%
2002	3405	4.7%
2001	1481	2.0%

VehicleAge
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	10
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	4.176643876

Minimum	0
Maximum	9
Zeros	2
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3
median	4
Q3	5
95-th percentile	7
Maximum	9
Range	9
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	1.712210288
Coefficient of variation (CV)	0.4099488342
Kurtosis	-0.2092717782
Mean	4.176643876
Median Absolute Deviation (MAD)	1
Skewness	0.3936160141
Sum	304824
Variance	2.93166407
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=10)

Value	Count	Frequency (%)
4	17013	23.3%
3	15902	21.8%
5	12956	17.8%
2	8482	11.6%
6	8022	11.0%
7	4646	6.4%
1	3094	4.2%
8	2220	3.0%
9	646	0.9%
0	2	< 0.1%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	2	< 0.1%
1	3094	4.2%
2	8482	11.6%
3	15902	21.8%
4	17013	23.3%
5	12956	17.8%
6	8022	11.0%
7	4646	6.4%
8	2220	3.0%
9	646	0.9%

Value	Count	Frequency (%)
9	646	0.9%
8	2220	3.0%
7	4646	6.4%
6	8022	11.0%
5	12956	17.8%
4	17013	23.3%
3	15902	21.8%
2	8482	11.6%
1	3094	4.2%
0	2	< 0.1%

Make
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	33
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	570.3 KiB

CHEVROLET	17248
DODGE	12912
FORD	11305
CHRYSLER	8844
PONTIAC	4258
Other values (28)	18416

Length

Max length	12
Median length	6
Mean length	6.431360728
Min length	3

Characters and Unicode

Total characters	469380
Distinct characters	26
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	2 ?
Unique (%)	< 0.1%

Sample

1st row	MAZDA
2nd row	DODGE
3rd row	DODGE
4th row	DODGE
5th row	FORD

Common Values

Value	Count	Frequency (%)
CHEVROLET	17248	23.6%
DODGE	12912	17.7%
FORD	11305	15.5%
CHRYSLER	8844	12.1%
PONTIAC	4258	5.8%
KIA	2484	3.4%
SATURN	2163	3.0%
NISSAN	2085	2.9%
HYUNDAI	1811	2.5%
JEEP	1644	2.3%
Other values (23)	8229	11.3%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
chevrolet	17248	23.6%
dodge	12912	17.7%
ford	11305	15.5%
chrysler	8844	12.1%
pontiac	4258	5.8%
kia	2484	3.4%
saturn	2163	3.0%
nissan	2085	2.9%
hyundai	1811	2.5%
jeep	1644	2.3%
Other values (22)	8230	11.3%

Most occurring characters

Value	Count	Frequency (%)
E	60862	13.0%
R	50292	10.7%
O	49433	10.5%
D	40692	8.7%
C	32958	7.0%
H	29433	6.3%
L	27042	5.8%
T	27033	5.8%
S	19265	4.1%
V	17456	3.7%
Other values (16)	114914	24.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	469379	> 99.9%
Space Separator	1	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	60862	13.0%
R	50292	10.7%
O	49433	10.5%
D	40692	8.7%
C	32958	7.0%
H	29433	6.3%
L	27042	5.8%
T	27033	5.8%
S	19265	4.1%
V	17456	3.7%
Other values (15)	114913	24.5%

Space Separator

Value	Count	Frequency (%)
	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	469379	> 99.9%
Common	1	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	60862	13.0%
R	50292	10.7%
O	49433	10.5%
D	40692	8.7%
C	32958	7.0%
H	29433	6.3%
L	27042	5.8%
T	27033	5.8%
S	19265	4.1%
V	17456	3.7%
Other values (15)	114913	24.5%

Common

Value	Count	Frequency (%)
	1	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	469380	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	60862	13.0%
R	50292	10.7%
O	49433	10.5%
D	40692	8.7%
C	32958	7.0%
H	29433	6.3%
L	27042	5.8%
T	27033	5.8%
S	19265	4.1%
V	17456	3.7%
Other values (16)	114914	24.5%

Model
Categorical

HIGH CARDINALITY

Distinct	1063
Distinct (%)	1.5%
Missing	0
Missing (%)	0.0%
Memory size	570.3 KiB

PT CRUISER	2329
IMPALA	1990
TAURUS	1425
CALIBER	1375
CARAVAN GRAND FWD V6	1289
Other values (1058)	64575

Length

Max length	20
Median length	15
Mean length	13.72755299
Min length	2

Characters and Unicode

Total characters	1001878
Distinct characters	54
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	161 ?
Unique (%)	0.2%

Sample

1st row	MAZDA3
2nd row	1500 RAM PICKUP 2WD
3rd row	STRATUS V6
4th row	NEON
5th row	FOCUS

Common Values

Value	Count	Frequency (%)
PT CRUISER	2329	3.2%
IMPALA	1990	2.7%
TAURUS	1425	2.0%
CALIBER	1375	1.9%
CARAVAN GRAND FWD V6	1289	1.8%
MALIBU 4C	1225	1.7%
TAURUS 3.0L V6 EFI	1160	1.6%
SEBRING 4C	1157	1.6%
COBALT	1106	1.5%
PT CRUISER 2.4L I4 S	1104	1.5%
Other values (1053)	58823	80.6%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
v6	28571	13.1%
4c	11229	5.2%
2wd	11009	5.1%
i4	9070	4.2%
fwd	7197	3.3%
impala	4784	2.2%
grand	4222	1.9%
2.4l	3777	1.7%
cruiser	3729	1.7%
pt	3728	1.7%
Other values (378)	130515	59.9%

Most occurring characters

Value	Count	Frequency (%)
	144848	14.5%
A	69116	6.9%
I	57763	5.8%
R	56212	5.6%
L	49160	4.9%
E	46182	4.6%
V	42246	4.2%
C	38735	3.9%
D	35650	3.6%
S	32873	3.3%
Other values (44)	429093	42.8%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	691118	69.0%
Space Separator	144848	14.5%
Decimal Number	137332	13.7%
Other Punctuation	26845	2.7%
Dash Punctuation	929	0.1%
Lowercase Letter	806	0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	69116	10.0%
I	57763	8.4%
R	56212	8.1%
L	49160	7.1%
E	46182	6.7%
V	42246	6.1%
C	38735	5.6%
D	35650	5.2%
S	32873	4.8%
N	30923	4.5%
Other values (16)	232258	33.6%

Lowercase Letter

Value	Count	Frequency (%)
i	152	18.9%
e	128	15.9%
p	91	11.3%
n	77	9.6%
c	64	7.9%
s	63	7.8%
f	63	7.8%
l	58	7.2%
d	40	5.0%
u	30	3.7%
Other values (3)	40	5.0%

Decimal Number

Value	Count	Frequency (%)
6	32866	23.9%
4	32548	23.7%
2	25694	18.7%
3	12674	9.2%
0	12447	9.1%
5	7496	5.5%
8	5606	4.1%
1	4118	3.0%
7	3163	2.3%
9	720	0.5%

Other Punctuation

Value	Count	Frequency (%)
.	25344	94.4%
&	870	3.2%
/	631	2.4%

Space Separator

Value	Count	Frequency (%)
	144848	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	929	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	691924	69.1%
Common	309954	30.9%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	69116	10.0%
I	57763	8.3%
R	56212	8.1%
L	49160	7.1%
E	46182	6.7%
V	42246	6.1%
C	38735	5.6%
D	35650	5.2%
S	32873	4.8%
N	30923	4.5%
Other values (29)	233064	33.7%

Common

Value	Count	Frequency (%)
	144848	46.7%
6	32866	10.6%
4	32548	10.5%
2	25694	8.3%
.	25344	8.2%
3	12674	4.1%
0	12447	4.0%
5	7496	2.4%
8	5606	1.8%
1	4118	1.3%
Other values (5)	6313	2.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	1001878	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	144848	14.5%
A	69116	6.9%
I	57763	5.8%
R	56212	5.6%
L	49160	4.9%
E	46182	4.6%
V	42246	4.2%
C	38735	3.9%
D	35650	3.6%
S	32873	3.3%
Other values (44)	429093	42.8%

Trim
Categorical

HIGH CARDINALITY
MISSING

Distinct	134
Distinct (%)	0.2%
Missing	2360
Missing (%)	3.2%
Memory size	570.3 KiB

Bas	13950
LS	10174
SE	9348
SXT	3825
LT	3540
Other values (129)	29786

Length

Max length	3
Median length	3
Mean length	2.46630701
Min length	1

Characters and Unicode

Total characters	174178
Distinct characters	53
Distinct categories	6 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	10 ?
Unique (%)	< 0.1%

Sample

1st row	i
2nd row	ST
3rd row	SXT
4th row	SXT
5th row	ZX3

Common Values

Value	Count	Frequency (%)
Bas	13950	19.1%
LS	10174	13.9%
SE	9348	12.8%
SXT	3825	5.2%
LT	3540	4.9%
LX	2417	3.3%
Tou	2256	3.1%
EX	2120	2.9%
SEL	1360	1.9%
XLT	1357	1.9%
Other values (124)	20276	27.8%
(Missing)	2360	3.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
bas	13950	19.8%
ls	10174	14.4%
se	9355	13.2%
sxt	3825	5.4%
lt	3540	5.0%
lx	2417	3.4%
tou	2256	3.2%
ex	2128	3.0%
sel	1360	1.9%
xlt	1357	1.9%
Other values (120)	20269	28.7%

Most occurring characters

Value	Count	Frequency (%)
S	34510	19.8%
L	26771	15.4%
E	16127	9.3%
a	15400	8.8%
T	14479	8.3%
s	14462	8.3%
B	13950	8.0%
X	13100	7.5%
o	3972	2.3%
G	3038	1.7%
Other values (43)	18369	10.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	126188	72.4%
Lowercase Letter	43845	25.2%
Decimal Number	3976	2.3%
Other Punctuation	146	0.1%
Dash Punctuation	15	< 0.1%
Space Separator	8	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
S	34510	27.3%
L	26771	21.2%
E	16127	12.8%
T	14479	11.5%
B	13950	11.1%
X	13100	10.4%
G	3038	2.4%
C	1423	1.1%
Z	1144	0.9%
N	448	0.4%
Other values (13)	1198	0.9%

Lowercase Letter

Value	Count	Frequency (%)
a	15400	35.1%
s	14462	33.0%
o	3972	9.1%
u	2622	6.0%
i	1601	3.7%
r	1493	3.4%
p	1281	2.9%
m	965	2.2%
d	761	1.7%
l	526	1.2%
Other values (9)	762	1.7%

Decimal Number

Value	Count	Frequency (%)
2	965	24.3%
3	622	15.6%
4	620	15.6%
1	588	14.8%
0	582	14.6%
5	466	11.7%
6	87	2.2%
7	46	1.2%

Dash Punctuation

Value	Count	Frequency (%)
-	15	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	146	100.0%

Space Separator

Value	Count	Frequency (%)
	8	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	170033	97.6%
Common	4145	2.4%

Most frequent character per script

Latin

Value	Count	Frequency (%)
S	34510	20.3%
L	26771	15.7%
E	16127	9.5%
a	15400	9.1%
T	14479	8.5%
s	14462	8.5%
B	13950	8.2%
X	13100	7.7%
o	3972	2.3%
G	3038	1.8%
Other values (32)	14224	8.4%

Common

Value	Count	Frequency (%)
2	965	23.3%
3	622	15.0%
4	620	15.0%
1	588	14.2%
0	582	14.0%
5	466	11.2%
/	146	3.5%
6	87	2.1%
7	46	1.1%
-	15	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	174178	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
S	34510	19.8%
L	26771	15.4%
E	16127	9.3%
a	15400	8.8%
T	14479	8.3%
s	14462	8.3%
B	13950	8.0%
X	13100	7.5%
o	3972	2.3%
G	3038	1.7%
Other values (43)	18369	10.5%

SubModel
Categorical

HIGH CARDINALITY

Distinct	863
Distinct (%)	1.2%
Missing	8
Missing (%)	< 0.1%
Memory size	570.3 KiB

4D SEDAN	15236
4D SEDAN LS	4718
4D SEDAN SE	3859
4D WAGON	2230
MINIVAN 3.3L	1258
Other values (858)	45674

Length

Max length	32
Median length	11
Mean length	12.20298732
Min length	4

Characters and Unicode

Total characters	890513
Distinct characters	40
Distinct categories	5 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	161 ?
Unique (%)	0.2%

Sample

1st row	4D SEDAN I
2nd row	QUAD CAB 4.7L SLT
3rd row	4D SEDAN SXT FFV
4th row	4D SEDAN
5th row	2D COUPE ZX3

Common Values

Value	Count	Frequency (%)
4D SEDAN	15236	20.9%
4D SEDAN LS	4718	6.5%
4D SEDAN SE	3859	5.3%
4D WAGON	2230	3.1%
MINIVAN 3.3L	1258	1.7%
4D SUV 4.2L LS	1193	1.6%
4D SEDAN LT	1129	1.5%
4D SEDAN SXT FFV	1094	1.5%
2D COUPE	1072	1.5%
4D SEDAN LX	1068	1.5%
Other values (853)	40118	55.0%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
4d	59830	27.6%
sedan	42228	19.5%
ls	9143	4.2%
suv	8391	3.9%
se	5949	2.7%
wagon	4162	1.9%
cab	3908	1.8%
sport	3538	1.6%
ffv	3394	1.6%
2d	3354	1.5%
Other values (263)	72555	33.5%

Most occurring characters

Value	Count	Frequency (%)
	143477	16.1%
D	109412	12.3%
S	86882	9.8%
E	72405	8.1%
4	68475	7.7%
A	60312	6.8%
N	56943	6.4%
L	50509	5.7%
T	24523	2.8%
.	21718	2.4%
Other values (30)	195857	22.0%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	614121	69.0%
Space Separator	143477	16.1%
Decimal Number	110941	12.5%
Other Punctuation	21824	2.5%
Dash Punctuation	150	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
D	109412	17.8%
S	86882	14.1%
E	72405	11.8%
A	60312	9.8%
N	56943	9.3%
L	50509	8.2%
T	24523	4.0%
U	19217	3.1%
V	18892	3.1%
I	16424	2.7%
Other values (16)	98602	16.1%

Decimal Number

Value	Count	Frequency (%)
4	68475	61.7%
3	13952	12.6%
2	10987	9.9%
5	5597	5.0%
7	4029	3.6%
0	2799	2.5%
8	1576	1.4%
1	1220	1.1%
9	1188	1.1%
6	1118	1.0%

Other Punctuation

Value	Count	Frequency (%)
.	21718	99.5%
/	106	0.5%

Space Separator

Value	Count	Frequency (%)
	143477	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	150	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	614121	69.0%
Common	276392	31.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
D	109412	17.8%
S	86882	14.1%
E	72405	11.8%
A	60312	9.8%
N	56943	9.3%
L	50509	8.2%
T	24523	4.0%
U	19217	3.1%
V	18892	3.1%
I	16424	2.7%
Other values (16)	98602	16.1%

Common

Value	Count	Frequency (%)
	143477	51.9%
4	68475	24.8%
.	21718	7.9%
3	13952	5.0%
2	10987	4.0%
5	5597	2.0%
7	4029	1.5%
0	2799	1.0%
8	1576	0.6%
1	1220	0.4%
Other values (4)	2562	0.9%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	890513	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	143477	16.1%
D	109412	12.3%
S	86882	9.8%
E	72405	8.1%
4	68475	7.7%
A	60312	6.8%
N	56943	6.4%
L	50509	5.7%
T	24523	2.8%
.	21718	2.4%
Other values (30)	195857	22.0%

Color
Categorical

Distinct	16
Distinct (%)	< 0.1%
Missing	8
Missing (%)	< 0.1%
Memory size	570.3 KiB

SILVER	14875
WHITE	12123
BLUE	10347
GREY	7887
BLACK	7627
Other values (11)	20116

Length

Max length	9
Median length	5
Mean length	4.758136348
Min length	3

Characters and Unicode

Total characters	347225
Distinct characters	22
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	RED
2nd row	WHITE
3rd row	MAROON
4th row	SILVER
5th row	SILVER

Common Values

Value	Count	Frequency (%)
SILVER	14875	20.4%
WHITE	12123	16.6%
BLUE	10347	14.2%
GREY	7887	10.8%
BLACK	7627	10.5%
RED	6257	8.6%
GOLD	5231	7.2%
GREEN	3194	4.4%
MAROON	2046	2.8%
BEIGE	1584	2.2%
Other values (6)	1804	2.5%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
silver	14875	20.4%
white	12123	16.6%
blue	10347	14.2%
grey	7887	10.8%
black	7627	10.4%
red	6257	8.6%
gold	5231	7.2%
green	3194	4.4%
maroon	2046	2.8%
beige	1584	2.2%
Other values (7)	1898	2.6%

Most occurring characters

Value	Count	Frequency (%)
E	62319	17.9%
L	39035	11.2%
R	35725	10.3%
I	28676	8.3%
B	19994	5.8%
G	18311	5.3%
V	14969	4.3%
S	14875	4.3%
W	12803	3.7%
T	12459	3.6%
Other values (12)	88059	25.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	347131	> 99.9%
Space Separator	94	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	62319	18.0%
L	39035	11.2%
R	35725	10.3%
I	28676	8.3%
B	19994	5.8%
G	18311	5.3%
V	14969	4.3%
S	14875	4.3%
W	12803	3.7%
T	12459	3.6%
Other values (11)	87965	25.3%

Space Separator

Value	Count	Frequency (%)
	94	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	347131	> 99.9%
Common	94	< 0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	62319	18.0%
L	39035	11.2%
R	35725	10.3%
I	28676	8.3%
B	19994	5.8%
G	18311	5.3%
V	14969	4.3%
S	14875	4.3%
W	12803	3.7%
T	12459	3.6%
Other values (11)	87965	25.3%

Common

Value	Count	Frequency (%)
	94	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	347225	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	62319	17.9%
L	39035	11.2%
R	35725	10.3%
I	28676	8.3%
B	19994	5.8%
G	18311	5.3%
V	14969	4.3%
S	14875	4.3%
W	12803	3.7%
T	12459	3.6%
Other values (12)	88059	25.4%

Transmission
Categorical

Distinct	3
Distinct (%)	< 0.1%
Missing	9
Missing (%)	< 0.1%
Memory size	570.3 KiB

AUTO	70398
MANUAL	2575
Manual	1

Length

Max length	6
Median length	4
Mean length	4.070600488
Min length	4

Characters and Unicode

Total characters	297048
Distinct characters	11
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	< 0.1%

Sample

1st row	AUTO
2nd row	AUTO
3rd row	AUTO
4th row	AUTO
5th row	MANUAL

Common Values

Value	Count	Frequency (%)
AUTO	70398	96.5%
MANUAL	2575	3.5%
Manual	1	< 0.1%
(Missing)	9	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
auto	70398	96.5%
manual	2576	3.5%

Most occurring characters

Value	Count	Frequency (%)
A	75548	25.4%
U	72973	24.6%
T	70398	23.7%
O	70398	23.7%
M	2576	0.9%
N	2575	0.9%
L	2575	0.9%
a	2	< 0.1%
n	1	< 0.1%
u	1	< 0.1%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	297043	> 99.9%
Lowercase Letter	5	< 0.1%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	75548	25.4%
U	72973	24.6%
T	70398	23.7%
O	70398	23.7%
M	2576	0.9%
N	2575	0.9%
L	2575	0.9%

Lowercase Letter

Value	Count	Frequency (%)
a	2	40.0%
n	1	20.0%
u	1	20.0%
l	1	20.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	297048	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	75548	25.4%
U	72973	24.6%
T	70398	23.7%
O	70398	23.7%
M	2576	0.9%
N	2575	0.9%
L	2575	0.9%
a	2	< 0.1%
n	1	< 0.1%
u	1	< 0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	297048	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	75548	25.4%
U	72973	24.6%
T	70398	23.7%
O	70398	23.7%
M	2576	0.9%
N	2575	0.9%
L	2575	0.9%
a	2	< 0.1%
n	1	< 0.1%
u	1	< 0.1%

WheelTypeID
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	4
Distinct (%)	< 0.1%
Missing	3169
Missing (%)	4.3%
Memory size	570.3 KiB

1.0	36050
2.0	33004
3.0	755
0.0	5

Length

Max length	3
Median length	3
Mean length	3
Min length	3

Characters and Unicode

Total characters	209442
Distinct characters	5
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	1.0
2nd row	1.0
3rd row	2.0
4th row	1.0
5th row	2.0

Common Values

Value	Count	Frequency (%)
1.0	36050	49.4%
2.0	33004	45.2%
3.0	755	1.0%
0.0	5	< 0.1%
(Missing)	3169	4.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
1.0	36050	51.6%
2.0	33004	47.3%
3.0	755	1.1%
0.0	5	< 0.1%

Most occurring characters

Value	Count	Frequency (%)
0	69819	33.3%
.	69814	33.3%
1	36050	17.2%
2	33004	15.8%
3	755	0.4%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	139628	66.7%
Other Punctuation	69814	33.3%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	69819	50.0%
1	36050	25.8%
2	33004	23.6%
3	755	0.5%

Other Punctuation

Value	Count	Frequency (%)
.	69814	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Common	209442	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	69819	33.3%
.	69814	33.3%
1	36050	17.2%
2	33004	15.8%
3	755	0.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	209442	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	69819	33.3%
.	69814	33.3%
1	36050	17.2%
2	33004	15.8%
3	755	0.4%

WheelType
Categorical

HIGH CORRELATION
HIGH CORRELATION
MISSING

Distinct	3
Distinct (%)	< 0.1%
Missing	3174
Missing (%)	4.3%
Memory size	570.3 KiB

Alloy	36050
Covers	33004
Special	755

Length

Max length	7
Median length	5
Mean length	5.494406165
Min length	5

Characters and Unicode

Total characters	383559
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	Alloy
2nd row	Alloy
3rd row	Covers
4th row	Alloy
5th row	Covers

Common Values

Value	Count	Frequency (%)
Alloy	36050	49.4%
Covers	33004	45.2%
Special	755	1.0%
(Missing)	3174	4.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
alloy	36050	51.6%
covers	33004	47.3%
special	755	1.1%

Most occurring characters

Value	Count	Frequency (%)
l	72855	19.0%
o	69054	18.0%
A	36050	9.4%
y	36050	9.4%
e	33759	8.8%
C	33004	8.6%
v	33004	8.6%
r	33004	8.6%
s	33004	8.6%
S	755	0.2%
Other values (4)	3020	0.8%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	313750	81.8%
Uppercase Letter	69809	18.2%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
l	72855	23.2%
o	69054	22.0%
y	36050	11.5%
e	33759	10.8%
v	33004	10.5%
r	33004	10.5%
s	33004	10.5%
p	755	0.2%
c	755	0.2%
i	755	0.2%

Uppercase Letter

Value	Count	Frequency (%)
A	36050	51.6%
C	33004	47.3%
S	755	1.1%

Most occurring scripts

Value	Count	Frequency (%)
Latin	383559	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
l	72855	19.0%
o	69054	18.0%
A	36050	9.4%
y	36050	9.4%
e	33759	8.8%
C	33004	8.6%
v	33004	8.6%
r	33004	8.6%
s	33004	8.6%
S	755	0.2%
Other values (4)	3020	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	383559	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
l	72855	19.0%
o	69054	18.0%
A	36050	9.4%
y	36050	9.4%
e	33759	8.8%
C	33004	8.6%
v	33004	8.6%
r	33004	8.6%
s	33004	8.6%
S	755	0.2%
Other values (4)	3020	0.8%

VehOdo
Real number (ℝ_≥0)

Distinct	39947
Distinct (%)	54.7%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	71499.99592

Minimum	4825
Maximum	115717
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	4825
5-th percentile	45477
Q1	61837
median	73361
Q3	82436
95-th percentile	92521.8
Maximum	115717
Range	110892
Interquartile range (IQR)	20599

Descriptive statistics

Standard deviation	14578.91313
Coefficient of variation (CV)	0.2039008946
Kurtosis	-0.1987398752
Mean	71499.99592
Median Absolute Deviation (MAD)	10099
Skewness	-0.4531454298
Sum	5218284202
Variance	212544708
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
75009	10	< 0.1%
77995	10	< 0.1%
67464	9	< 0.1%
75371	9	< 0.1%
79015	9	< 0.1%
71225	9	< 0.1%
77449	8	< 0.1%
85884	8	< 0.1%
80810	8	< 0.1%
67953	8	< 0.1%
Other values (39937)	72895	99.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
4825	1	< 0.1%
5368	1	< 0.1%
8706	1	< 0.1%
9446	1	< 0.1%
9878	1	< 0.1%
10095	1	< 0.1%
10643	1	< 0.1%
11662	1	< 0.1%
12628	1	< 0.1%
12926	1	< 0.1%

Value	Count	Frequency (%)
115717	1	< 0.1%
115026	1	< 0.1%
114184	1	< 0.1%
113617	1	< 0.1%
112056	1	< 0.1%
112029	1	< 0.1%
110318	1	< 0.1%
110119	1	< 0.1%
110071	1	< 0.1%
110055	1	< 0.1%

Nationality
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	5
Missing (%)	< 0.1%
Memory size	570.3 KiB

AMERICAN	61028
OTHER ASIAN	8033
TOP LINE ASIAN	3722
OTHER	195

Length

Max length	14
Median length	8
Mean length	8.628216723
Min length	5

Characters and Unicode

Total characters	629670
Distinct characters	14
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	OTHER ASIAN
2nd row	AMERICAN
3rd row	AMERICAN
4th row	AMERICAN
5th row	AMERICAN

Common Values

Value	Count	Frequency (%)
AMERICAN	61028	83.6%
OTHER ASIAN	8033	11.0%
TOP LINE ASIAN	3722	5.1%
OTHER	195	0.3%
(Missing)	5	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
american	61028	69.0%
asian	11755	13.3%
other	8228	9.3%
line	3722	4.2%
top	3722	4.2%

Most occurring characters

Value	Count	Frequency (%)
A	145566	23.1%
I	76505	12.2%
N	76505	12.2%
E	72978	11.6%
R	69256	11.0%
M	61028	9.7%
C	61028	9.7%
	15477	2.5%
O	11950	1.9%
T	11950	1.9%
Other values (4)	27427	4.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	614193	97.5%
Space Separator	15477	2.5%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
A	145566	23.7%
I	76505	12.5%
N	76505	12.5%
E	72978	11.9%
R	69256	11.3%
M	61028	9.9%
C	61028	9.9%
O	11950	1.9%
T	11950	1.9%
S	11755	1.9%
Other values (3)	15672	2.6%

Space Separator

Value	Count	Frequency (%)
	15477	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	614193	97.5%
Common	15477	2.5%

Most frequent character per script

Latin

Value	Count	Frequency (%)
A	145566	23.7%
I	76505	12.5%
N	76505	12.5%
E	72978	11.9%
R	69256	11.3%
M	61028	9.9%
C	61028	9.9%
O	11950	1.9%
T	11950	1.9%
S	11755	1.9%
Other values (3)	15672	2.6%

Common

Value	Count	Frequency (%)
	15477	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	629670	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
A	145566	23.1%
I	76505	12.2%
N	76505	12.2%
E	72978	11.6%
R	69256	11.0%
M	61028	9.7%
C	61028	9.7%
	15477	2.5%
O	11950	1.9%
T	11950	1.9%
Other values (4)	27427	4.4%

Size
Categorical

HIGH CORRELATION

Distinct	12
Distinct (%)	< 0.1%
Missing	5
Missing (%)	< 0.1%
Memory size	570.3 KiB

MEDIUM	30785
LARGE	8850
MEDIUM SUV	8090
COMPACT	7205
VAN	5854
Other values (7)	12194

Length

Max length	11
Median length	6
Mean length	6.760119488
Min length	3

Characters and Unicode

Total characters	493340
Distinct characters	19
Distinct categories	2 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	MEDIUM
2nd row	LARGE TRUCK
3rd row	MEDIUM
4th row	COMPACT
5th row	COMPACT

Common Values

Value	Count	Frequency (%)
MEDIUM	30785	42.2%
LARGE	8850	12.1%
MEDIUM SUV	8090	11.1%
COMPACT	7205	9.9%
VAN	5854	8.0%
LARGE TRUCK	3170	4.3%
SMALL SUV	2276	3.1%
SPECIALTY	1915	2.6%
CROSSOVER	1759	2.4%
LARGE SUV	1433	2.0%
Other values (2)	1641	2.2%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
medium	38875	43.8%
large	13453	15.1%
suv	11799	13.3%
compact	7205	8.1%
van	5854	6.6%
truck	4034	4.5%
small	3140	3.5%
specialty	1915	2.2%
crossover	1759	2.0%
sports	777	0.9%

Most occurring characters

Value	Count	Frequency (%)
M	88095	17.9%
E	56002	11.4%
U	54708	11.1%
I	40790	8.3%
D	38875	7.9%
A	31567	6.4%
C	22118	4.5%
S	21926	4.4%
R	21782	4.4%
L	21648	4.4%
Other values (9)	95829	19.4%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	477507	96.8%
Space Separator	15833	3.2%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
M	88095	18.4%
E	56002	11.7%
U	54708	11.5%
I	40790	8.5%
D	38875	8.1%
A	31567	6.6%
C	22118	4.6%
S	21926	4.6%
R	21782	4.6%
L	21648	4.5%
Other values (8)	79996	16.8%

Space Separator

Value	Count	Frequency (%)
	15833	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	477507	96.8%
Common	15833	3.2%

Most frequent character per script

Latin

Value	Count	Frequency (%)
M	88095	18.4%
E	56002	11.7%
U	54708	11.5%
I	40790	8.5%
D	38875	8.1%
A	31567	6.6%
C	22118	4.6%
S	21926	4.6%
R	21782	4.6%
L	21648	4.5%
Other values (8)	79996	16.8%

Common

Value	Count	Frequency (%)
	15833	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	493340	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
M	88095	17.9%
E	56002	11.4%
U	54708	11.1%
I	40790	8.3%
D	38875	7.9%
A	31567	6.4%
C	22118	4.5%
S	21926	4.4%
R	21782	4.4%
L	21648	4.4%
Other values (9)	95829	19.4%

TopThreeAmericanName
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	4
Distinct (%)	< 0.1%
Missing	5
Missing (%)	< 0.1%
Memory size	570.3 KiB

GM	25314
CHRYSLER	23399
FORD	12315
OTHER	11950

Length

Max length	8
Median length	4
Mean length	4.752528159
Min length	2

Characters and Unicode

Total characters	346830
Distinct characters	13
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	OTHER
2nd row	CHRYSLER
3rd row	CHRYSLER
4th row	CHRYSLER
5th row	FORD

Common Values

Value	Count	Frequency (%)
GM	25314	34.7%
CHRYSLER	23399	32.1%
FORD	12315	16.9%
OTHER	11950	16.4%
(Missing)	5	< 0.1%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
gm	25314	34.7%
chrysler	23399	32.1%
ford	12315	16.9%
other	11950	16.4%

Most occurring characters

Value	Count	Frequency (%)
R	71063	20.5%
H	35349	10.2%
E	35349	10.2%
G	25314	7.3%
M	25314	7.3%
O	24265	7.0%
C	23399	6.7%
Y	23399	6.7%
S	23399	6.7%
L	23399	6.7%
Other values (3)	36580	10.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	346830	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
R	71063	20.5%
H	35349	10.2%
E	35349	10.2%
G	25314	7.3%
M	25314	7.3%
O	24265	7.0%
C	23399	6.7%
Y	23399	6.7%
S	23399	6.7%
L	23399	6.7%
Other values (3)	36580	10.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	346830	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
R	71063	20.5%
H	35349	10.2%
E	35349	10.2%
G	25314	7.3%
M	25314	7.3%
O	24265	7.0%
C	23399	6.7%
Y	23399	6.7%
S	23399	6.7%
L	23399	6.7%
Other values (3)	36580	10.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	346830	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
R	71063	20.5%
H	35349	10.2%
E	35349	10.2%
G	25314	7.3%
M	25314	7.3%
O	24265	7.0%
C	23399	6.7%
Y	23399	6.7%
S	23399	6.7%
L	23399	6.7%
Other values (3)	36580	10.5%

MMRAcquisitionAuctionAveragePrice
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	10342
Distinct (%)	14.2%
Missing	18
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	6128.909217

Minimum	0
Maximum	35722
Zeros	828
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2583
Q1	4273
median	6097
Q3	7765
95-th percentile	10244
Maximum	35722
Range	35722
Interquartile range (IQR)	3492

Descriptive statistics

Standard deviation	2461.992768
Coefficient of variation (CV)	0.4017016212
Kurtosis	1.593727547
Mean	6128.909217
Median Absolute Deviation (MAD)	1743
Skewness	0.4636405627
Sum	447195861
Variance	6061408.392
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	828	1.1%
5480	368	0.5%
5569	233	0.3%
6311	174	0.2%
6858	137	0.2%
7644	121	0.2%
4573	110	0.2%
8196	103	0.1%
6892	93	0.1%
7048	91	0.1%
Other values (10332)	70707	96.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	828	1.1%
884	1	< 0.1%
889	1	< 0.1%
966	1	< 0.1%
1004	1	< 0.1%
1010	1	< 0.1%
1027	1	< 0.1%
1064	1	< 0.1%
1097	1	< 0.1%
1120	1	< 0.1%

Value	Count	Frequency (%)
35722	1	< 0.1%
33543	1	< 0.1%
32250	1	< 0.1%
32063	1	< 0.1%
28354	1	< 0.1%
28077	1	< 0.1%
27680	1	< 0.1%
25033	1	< 0.1%
23581	1	< 0.1%
23031	1	< 0.1%

MMRAcquisitionAuctionCleanPrice
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	11379
Distinct (%)	15.6%
Missing	18
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	7373.636031

Minimum	0
Maximum	36859
Zeros	697
Zeros (%)	1.0%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	0
5-th percentile	3500
Q1	5406
median	7303
Q3	9021
95-th percentile	12030.8
Maximum	36859
Range	36859
Interquartile range (IQR)	3615

Descriptive statistics

Standard deviation	2722.491986
Coefficient of variation (CV)	0.369219741
Kurtosis	1.651146564
Mean	7373.636031
Median Absolute Deviation (MAD)	1792
Skewness	0.4665008675
Sum	538017353
Variance	7411962.611
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	697	1.0%
6461	374	0.5%
6584	225	0.3%
7450	179	0.2%
8107	133	0.2%
1	131	0.2%
8892	122	0.2%
9044	109	0.1%
5967	96	0.1%
7614	89	0.1%
Other values (11369)	70810	97.0%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	697	1.0%
1	131	0.2%
1076	1	< 0.1%
1240	1	< 0.1%
1397	1	< 0.1%
1437	1	< 0.1%
1535	1	< 0.1%
1587	1	< 0.1%
1610	1	< 0.1%
1634	1	< 0.1%

Value	Count	Frequency (%)
36859	1	< 0.1%
36701	1	< 0.1%
35215	1	< 0.1%
35108	1	< 0.1%
30408	1	< 0.1%
30114	1	< 0.1%
29498	1	< 0.1%
28053	1	< 0.1%
26763	1	< 0.1%
25681	1	< 0.1%

MMRAcquisitionRetailAveragePrice
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	12725
Distinct (%)	17.4%
Missing	18
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	8497.034332

Minimum	0
Maximum	39080
Zeros	828
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	0
5-th percentile	3617.2
Q1	6280
median	8444
Q3	10651
95-th percentile	13742
Maximum	39080
Range	39080
Interquartile range (IQR)	4371

Descriptive statistics

Standard deviation	3156.285284
Coefficient of variation (CV)	0.3714572827
Kurtosis	0.680599336
Mean	8497.034332
Median Absolute Deviation (MAD)	2188
Skewness	0.2092142255
Sum	619986110
Variance	9962136.791
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	828	1.1%
6418	369	0.5%
6515	230	0.3%
7316	175	0.2%
7907	136	0.2%
8756	126	0.2%
9352	103	0.1%
5439	96	0.1%
11114	87	0.1%
7943	86	0.1%
Other values (12715)	70729	96.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	828	1.1%
1455	1	< 0.1%
1543	1	< 0.1%
1584	1	< 0.1%
1591	1	< 0.1%
1609	1	< 0.1%
1649	1	< 0.1%
1738	1	< 0.1%
1781	1	< 0.1%
1801	1	< 0.1%

Value	Count	Frequency (%)
39080	1	< 0.1%
37885	1	< 0.1%
36726	1	< 0.1%
35330	1	< 0.1%
33872	1	< 0.1%
31599	1	< 0.1%
30196	1	< 0.1%
30048	1	< 0.1%
29269	1	< 0.1%
27295	1	< 0.1%

MMRAcquisitonRetailCleanPrice
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
ZEROS

Distinct	13456
Distinct (%)	18.4%
Missing	18
Missing (%)	< 0.1%
Infinite	0
Infinite (%)	0.0%
Mean	9850.92824

Minimum	0
Maximum	41482
Zeros	828
Zeros (%)	1.1%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	0
5-th percentile	4646.2
Q1	7493
median	9789
Q3	12088
95-th percentile	15454.8
Maximum	41482
Range	41482
Interquartile range (IQR)	4595

Descriptive statistics

Standard deviation	3385.789541
Coefficient of variation (CV)	0.3437025891
Kurtosis	0.9248267411
Mean	9850.92824
Median Absolute Deviation (MAD)	2299
Skewness	0.1762997563
Sum	718772979
Variance	11463570.82
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	828	1.1%
7478	373	0.5%
7611	225	0.3%
8546	171	0.2%
9256	132	0.2%
10103	113	0.2%
10268	108	0.1%
6944	95	0.1%
11562	83	0.1%
9613	82	0.1%
Other values (13446)	70755	96.9%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	828	1.1%
1662	1	< 0.1%
2009	1	< 0.1%
2239	1	< 0.1%
2265	1	< 0.1%
2267	1	< 0.1%
2274	1	< 0.1%
2284	1	< 0.1%
2400	1	< 0.1%
2401	1	< 0.1%

Value	Count	Frequency (%)
41482	1	< 0.1%
40308	1	< 0.1%
40137	1	< 0.1%
38532	1	< 0.1%
36096	1	< 0.1%
33988	1	< 0.1%
33736	1	< 0.1%
32760	1	< 0.1%
32383	1	< 0.1%
29981	1	< 0.1%

MMRCurrentAuctionAveragePrice
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	10315
Distinct (%)	14.2%
Missing	315
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	6132.081287

Minimum	0
Maximum	35722
Zeros	504
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	0
5-th percentile	2617
Q1	4275
median	6062
Q3	7736
95-th percentile	10245.65
Maximum	35722
Range	35722
Interquartile range (IQR)	3461

Descriptive statistics

Standard deviation	2434.567723
Coefficient of variation (CV)	0.3970214368
Kurtosis	1.52993942
Mean	6132.081287
Median Absolute Deviation (MAD)	1726
Skewness	0.52258321
Sum	445606083
Variance	5927119.998
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	504	0.7%
5480	280	0.4%
5569	198	0.3%
6311	142	0.2%
8186	129	0.2%
7269	126	0.2%
6858	117	0.2%
7644	101	0.1%
8196	95	0.1%
8033	84	0.1%
Other values (10305)	70892	97.1%
(Missing)	315	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	504	0.7%
369	1	< 0.1%
430	1	< 0.1%
433	1	< 0.1%
665	2	< 0.1%
727	1	< 0.1%
733	1	< 0.1%
740	1	< 0.1%
799	1	< 0.1%
806	1	< 0.1%

Value	Count	Frequency (%)
35722	1	< 0.1%
33369	1	< 0.1%
32250	1	< 0.1%
31127	1	< 0.1%
28099	1	< 0.1%
27795	1	< 0.1%
27543	1	< 0.1%
23400	1	< 0.1%
23015	1	< 0.1%
21940	1	< 0.1%

MMRCurrentAuctionCleanPrice
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	11265
Distinct (%)	15.5%
Missing	315
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	7390.681827

Minimum	0
Maximum	36859
Zeros	378
Zeros (%)	0.5%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	0
5-th percentile	3540
Q1	5414
median	7313
Q3	9013
95-th percentile	12032.3
Maximum	36859
Range	36859
Interquartile range (IQR)	3599

Descriptive statistics

Standard deviation	2686.248852
Coefficient of variation (CV)	0.3634642804
Kurtosis	1.565619526
Mean	7390.681827
Median Absolute Deviation (MAD)	1794
Skewness	0.5355246484
Sum	537066067
Variance	7215932.892
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	378	0.5%
6461	284	0.4%
6584	184	0.3%
7450	140	0.2%
8107	127	0.2%
1	126	0.2%
8892	103	0.1%
9279	99	0.1%
7898	99	0.1%
9044	95	0.1%
Other values (11255)	71033	97.3%
(Missing)	315	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	378	0.5%
1	126	0.2%
494	1	< 0.1%
651	1	< 0.1%
793	1	< 0.1%
897	1	< 0.1%
1005	1	< 0.1%
1072	2	< 0.1%
1132	1	< 0.1%
1168	1	< 0.1%

Value	Count	Frequency (%)
36859	1	< 0.1%
36478	1	< 0.1%
35215	1	< 0.1%
34798	1	< 0.1%
30136	1	< 0.1%
29811	1	< 0.1%
29042	1	< 0.1%
26462	1	< 0.1%
26168	1	< 0.1%
25847	1	< 0.1%

MMRCurrentRetailAveragePrice
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	12493
Distinct (%)	17.2%
Missing	315
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	8775.723331

Minimum	0
Maximum	39080
Zeros	504
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	0
5-th percentile	3901.35
Q1	6536
median	8729
Q3	10911
95-th percentile	13853.65
Maximum	39080
Range	39080
Interquartile range (IQR)	4375

Descriptive statistics

Standard deviation	3090.702941
Coefficient of variation (CV)	0.3521878282
Kurtosis	0.6388495545
Mean	8775.723331
Median Absolute Deviation (MAD)	2188
Skewness	0.2013561618
Sum	637714263
Variance	9552444.669
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	504	0.7%
6418	274	0.4%
6515	184	0.3%
7316	141	0.2%
7907	118	0.2%
11674	106	0.1%
8756	103	0.1%
9352	94	0.1%
10834	92	0.1%
5439	70	0.1%
Other values (12483)	70982	97.3%
(Missing)	315	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	504	0.7%
899	1	< 0.1%
964	1	< 0.1%
968	1	< 0.1%
1218	2	< 0.1%
1285	1	< 0.1%
1292	1	< 0.1%
1299	1	< 0.1%
1363	1	< 0.1%
1370	1	< 0.1%

Value	Count	Frequency (%)
39080	1	< 0.1%
38151	1	< 0.1%
36539	1	< 0.1%
35330	1	< 0.1%
32928	1	< 0.1%
31128	1	< 0.1%
29921	1	< 0.1%
29752	1	< 0.1%
28050	1	< 0.1%
27269	1	< 0.1%

MMRCurrentRetailCleanPrice
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	13192
Distinct (%)	18.2%
Missing	315
Missing (%)	0.4%
Infinite	0
Infinite (%)	0.0%
Mean	10145.38531

Minimum	0
Maximum	41062
Zeros	504
Zeros (%)	0.7%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	0
5-th percentile	4960
Q1	7784
median	10103
Q3	12309
95-th percentile	15615
Maximum	41062
Range	41062
Interquartile range (IQR)	4525

Descriptive statistics

Standard deviation	3310.254351
Coefficient of variation (CV)	0.3262817772
Kurtosis	0.8470080707
Mean	10145.38531
Median Absolute Deviation (MAD)	2260
Skewness	0.1947799958
Sum	737244860
Variance	10957783.87
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	504	0.7%
7478	279	0.4%
7611	186	0.3%
8546	137	0.2%
9256	114	0.2%
10103	104	0.1%
10268	95	0.1%
12864	90	0.1%
11413	89	0.1%
12387	77	0.1%
Other values (13182)	70993	97.3%
(Missing)	315	0.4%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
0	504	0.7%
1034	1	< 0.1%
1203	1	< 0.1%
1356	1	< 0.1%
1469	1	< 0.1%
1585	1	< 0.1%
1658	2	< 0.1%
1723	1	< 0.1%
1814	1	< 0.1%
1838	1	< 0.1%

Value	Count	Frequency (%)
41062	1	< 0.1%
40308	1	< 0.1%
39896	1	< 0.1%
38532	1	< 0.1%
35366	1	< 0.1%
33337	1	< 0.1%
33014	1	< 0.1%
31744	1	< 0.1%
31317	1	< 0.1%
30194	1	< 0.1%

PRIMEUNIT
Boolean

HIGH CORRELATION
MISSING

Distinct	2
Distinct (%)	0.1%
Missing	69564
Missing (%)	95.3%
Memory size	142.7 KiB

False	3357
True	62
(Missing)	69564

Common Values
Chart

Value	Count	Frequency (%)
False	3357	4.6%
True	62	0.1%
(Missing)	69564	95.3%

AUCGUART
Categorical

MISSING

Distinct	2
Distinct (%)	0.1%
Missing	69564
Missing (%)	95.3%
Memory size	570.3 KiB

GREEN	3340
RED	79

Length

Max length	5
Median length	5
Mean length	4.953787657
Min length	3

Characters and Unicode

Total characters	16937
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	GREEN
2nd row	GREEN
3rd row	GREEN
4th row	GREEN
5th row	GREEN

Common Values

Value	Count	Frequency (%)
GREEN	3340	4.6%
RED	79	0.1%
(Missing)	69564	95.3%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
green	3340	97.7%
red	79	2.3%

Most occurring characters

Value	Count	Frequency (%)
E	6759	39.9%
R	3419	20.2%
G	3340	19.7%
N	3340	19.7%
D	79	0.5%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	16937	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
E	6759	39.9%
R	3419	20.2%
G	3340	19.7%
N	3340	19.7%
D	79	0.5%

Most occurring scripts

Value	Count	Frequency (%)
Latin	16937	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
E	6759	39.9%
R	3419	20.2%
G	3340	19.7%
N	3340	19.7%
D	79	0.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	16937	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
E	6759	39.9%
R	3419	20.2%
G	3340	19.7%
N	3340	19.7%
D	79	0.5%

BYRNO
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	74
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	26345.84216

Minimum	835
Maximum	99761
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	835
5-th percentile	1231
Q1	17212
median	19662
Q3	22808
95-th percentile	99761
Maximum	99761
Range	98926
Interquartile range (IQR)	5596

Descriptive statistics

Standard deviation	25717.35122
Coefficient of variation (CV)	0.9761445873
Kurtosis	3.474184178
Mean	26345.84216
Median Absolute Deviation (MAD)	2450
Skewness	2.129224775
Sum	1922798598
Variance	661382153.7
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
99761	3943	5.4%
18880	3588	4.9%
835	2987	4.1%
3453	2927	4.0%
22916	2852	3.9%
21053	2816	3.9%
19619	2738	3.8%
99750	2653	3.6%
17675	2617	3.6%
20928	2586	3.5%
Other values (64)	43276	59.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
835	2987	4.1%
1031	31	< 0.1%
1035	10	< 0.1%
1041	8	< 0.1%
1045	62	0.1%
1051	73	0.1%
1055	12	< 0.1%
1081	37	0.1%
1082	7	< 0.1%
1085	50	0.1%

Value	Count	Frequency (%)
99761	3943	5.4%
99760	2	< 0.1%
99750	2653	3.6%
99741	1	< 0.1%
99740	343	0.5%
53245	81	0.1%
52646	347	0.5%
52644	389	0.5%
52598	587	0.8%
52492	693	0.9%

VNZIP1
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	153
Distinct (%)	0.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	58043.05995

Minimum	2764
Maximum	99224
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	2764
5-th percentile	22801
Q1	32124
median	73108
Q3	80022
95-th percentile	92807
Maximum	99224
Range	96460
Interquartile range (IQR)	47898

Descriptive statistics

Standard deviation	26151.64041
Coefficient of variation (CV)	0.4505558535
Kurtosis	-1.688690677
Mean	58043.05995
Median Absolute Deviation (MAD)	21436
Skewness	-0.1035322325
Sum	4236156644
Variance	683908296.4
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
32824	3699	5.1%
27542	3402	4.7%
75236	2431	3.3%
74135	2321	3.2%
80022	2118	2.9%
85226	2086	2.9%
85040	2012	2.8%
29697	1999	2.7%
95673	1970	2.7%
28273	1887	2.6%
Other values (143)	49058	67.2%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
2764	15	< 0.1%
3106	97	0.1%
8505	317	0.4%
12552	6	< 0.1%
16066	6	< 0.1%
16137	2	< 0.1%
17028	33	< 0.1%
17406	139	0.2%
17545	136	0.2%
19440	531	0.7%

Value	Count	Frequency (%)
99224	5	< 0.1%
98064	131	0.2%
97402	11	< 0.1%
97217	136	0.2%
97060	64	0.1%
95673	1970	2.7%
94544	752	1.0%
92807	1086	1.5%
92504	385	0.5%
92337	811	1.1%

VNST
Categorical

HIGH CORRELATION
HIGH CORRELATION

Distinct	37
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Memory size	570.3 KiB

TX	13596
FL	10447
CA	7095
NC	7042
AZ	6174
Other values (32)	28629

Length

Max length	2
Median length	2
Mean length	2
Min length	2

Characters and Unicode

Total characters	145966
Distinct characters	24
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	FL
2nd row	FL
3rd row	FL
4th row	FL
5th row	FL

Common Values

Value	Count	Frequency (%)
TX	13596	18.6%
FL	10447	14.3%
CA	7095	9.7%
NC	7042	9.6%
AZ	6174	8.5%
CO	4998	6.8%
SC	4280	5.9%
OK	3594	4.9%
GA	2450	3.4%
TN	1764	2.4%
Other values (27)	11543	15.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
tx	13596	18.6%
fl	10447	14.3%
ca	7095	9.7%
nc	7042	9.6%
az	6174	8.5%
co	4998	6.8%
sc	4280	5.9%
ok	3594	4.9%
ga	2450	3.4%
tn	1764	2.4%
Other values (27)	11543	15.8%

Most occurring characters

Value	Count	Frequency (%)
C	23415	16.0%
A	19987	13.7%
T	16235	11.1%
X	13596	9.3%
L	11944	8.2%
N	10601	7.3%
F	10447	7.2%
O	10356	7.1%
Z	6174	4.2%
S	4773	3.3%
Other values (14)	18438	12.6%

Most occurring categories

Value	Count	Frequency (%)
Uppercase Letter	145966	100.0%

Most frequent character per category

Uppercase Letter

Value	Count	Frequency (%)
C	23415	16.0%
A	19987	13.7%
T	16235	11.1%
X	13596	9.3%
L	11944	8.2%
N	10601	7.3%
F	10447	7.2%
O	10356	7.1%
Z	6174	4.2%
S	4773	3.3%
Other values (14)	18438	12.6%

Most occurring scripts

Value	Count	Frequency (%)
Latin	145966	100.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
C	23415	16.0%
A	19987	13.7%
T	16235	11.1%
X	13596	9.3%
L	11944	8.2%
N	10601	7.3%
F	10447	7.2%
O	10356	7.1%
Z	6174	4.2%
S	4773	3.3%
Other values (14)	18438	12.6%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	145966	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
C	23415	16.0%
A	19987	13.7%
T	16235	11.1%
X	13596	9.3%
L	11944	8.2%
N	10601	7.3%
F	10447	7.2%
O	10356	7.1%
Z	6174	4.2%
S	4773	3.3%
Other values (14)	18438	12.6%

VehBCost
Real number (ℝ_≥0)

HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION
HIGH CORRELATION

Distinct	2072
Distinct (%)	2.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	6730.934326

Minimum	1
Maximum	45469
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	1
5-th percentile	4030
Q1	5435
median	6700
Q3	7900
95-th percentile	9775
Maximum	45469
Range	45468
Interquartile range (IQR)	2465

Descriptive statistics

Standard deviation	1767.846435
Coefficient of variation (CV)	0.2626450281
Kurtosis	8.144378254
Mean	6730.934326
Median Absolute Deviation (MAD)	1230
Skewness	0.7159313446
Sum	491243779.9
Variance	3125281.019
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
7500	777	1.1%
6500	588	0.8%
7200	586	0.8%
6000	582	0.8%
4200	553	0.8%
7000	550	0.8%
8000	541	0.7%
7800	516	0.7%
7100	460	0.6%
7400	456	0.6%
Other values (2062)	67374	92.3%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
1	1	< 0.1%
225	1	< 0.1%
1400	1	< 0.1%
1620	1	< 0.1%
1720	1	< 0.1%
1915	1	< 0.1%
1920	1	< 0.1%
1960	2	< 0.1%
2000	1	< 0.1%
2010	2	< 0.1%

Value	Count	Frequency (%)
45469	1	< 0.1%
38785	1	< 0.1%
36485	1	< 0.1%
35900	1	< 0.1%
32300	1	< 0.1%
29795	1	< 0.1%
28560	1	< 0.1%
28180	1	< 0.1%
23272.02	1	< 0.1%
20380	1	< 0.1%

IsOnlineSale
Categorical

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	570.3 KiB

0	71138
1	1845

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	72983
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	71138	97.5%
1	1845	2.5%

Length

Histogram of lengths of the category

Pie chart

Value	Count	Frequency (%)
0	71138	97.5%
1	1845	2.5%

Most occurring characters

Value	Count	Frequency (%)
0	71138	97.5%
1	1845	2.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	72983	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	71138	97.5%
1	1845	2.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	72983	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	71138	97.5%
1	1845	2.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	72983	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	71138	97.5%
1	1845	2.5%

WarrantyCost
Real number (ℝ_≥0)

HIGH CORRELATION

Distinct	281
Distinct (%)	0.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1276.580985

Minimum	462
Maximum	7498
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	570.3 KiB

Quantile statistics

Minimum	462
5-th percentile	569
Q1	837
median	1155
Q3	1623
95-th percentile	2198
Maximum	7498
Range	7036
Interquartile range (IQR)	786

Descriptive statistics

Standard deviation	598.8467882
Coefficient of variation (CV)	0.4691020745
Kurtosis	9.964807664
Mean	1276.580985
Median Absolute Deviation (MAD)	351
Skewness	2.070831169
Sum	93168710
Variance	358617.4757
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
920	2870	3.9%
1974	2407	3.3%
2152	2082	2.9%
1389	2078	2.8%
1215	2006	2.7%
1155	1878	2.6%
803	1690	2.3%
728	1663	2.3%
1503	1599	2.2%
1086	1579	2.2%
Other values (271)	53131	72.8%

Minimum 5 values
Maximum 5 values

Value	Count	Frequency (%)
462	412	0.6%
482	738	1.0%
505	1005	1.4%
522	17	< 0.1%
533	1174	1.6%
553	74	0.1%
569	1393	1.9%
582	165	0.2%
588	182	0.2%
594	932	1.3%

Value	Count	Frequency (%)
7498	1	< 0.1%
7198	1	< 0.1%
6819	2	< 0.1%
6519	1	< 0.1%
6492	2	< 0.1%
6208	2	< 0.1%
6192	2	< 0.1%
5913	36	< 0.1%
5908	2	< 0.1%
5613	35	< 0.1%

Pearson's r

The Pearson's correlation coefficient (r) is a measure of linear correlation between two variables. It's value lies between -1 and +1, -1 indicating total negative linear correlation, 0 indicating no linear correlation and 1 indicating total positive linear correlation. Furthermore, r is invariant under separate changes in location and scale of the two variables, implying that for a linear function the angle to the x-axis does not affect r.

To calculate r for two variables X and Y, one divides the covariance of X and Y by the product of their standard deviations.

Spearman's ρ

The Spearman's rank correlation coefficient (ρ) is a measure of monotonic correlation between two variables, and is therefore better in catching nonlinear monotonic correlations than Pearson's r. It's value lies between -1 and +1, -1 indicating total negative monotonic correlation, 0 indicating no monotonic correlation and 1 indicating total positive monotonic correlation.

To calculate ρ for two variables X and Y, one divides the covariance of the rank variables of X and Y by the product of their standard deviations.

Kendall's τ

Similarly to Spearman's rank correlation coefficient, the Kendall rank correlation coefficient (τ) measures ordinal association between two variables. It's value lies between -1 and +1, -1 indicating total negative correlation, 0 indicating no correlation and 1 indicating total positive correlation.

To calculate τ for two variables X and Y, one determines the number of concordant and discordant pairs of observations. τ is given by the number of concordant pairs minus the discordant pairs divided by the total number of pairs.

Phik (φk)

Phik (φk) is a new and practical correlation coefficient that works consistently between categorical, ordinal and interval variables, captures non-linear dependency and reverts to the Pearson correlation coefficient in case of a bivariate normal input distribution. There is extensive documentation available here.

Cramér's V (φc)

Cramér's V is an association measure for nominal random variables. The coefficient ranges from 0 to 1, with 0 indicating independence and 1 indicating perfect association. The empirical estimators used for Cramér's V have been proved to be biased, even for large samples. We use a bias-corrected measure that has been proposed by Bergsma in 2013 that can be found here.

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

The dendrogram allows you to more fully correlate variable completion, revealing trends deeper than the pairwise ones visible in the correlation heatmap.

First rows

	RefId	PurchDate	Auction	VehYear	VehicleAge	Make	Model	Trim	SubModel	Color	Transmission	WheelTypeID	WheelType	VehOdo	Nationality	Size	TopThreeAmericanName	MMRAcquisitionAuctionAveragePrice	MMRAcquisitionAuctionCleanPrice	MMRAcquisitionRetailAveragePrice	MMRAcquisitonRetailCleanPrice	MMRCurrentAuctionAveragePrice	MMRCurrentAuctionCleanPrice	MMRCurrentRetailAveragePrice	MMRCurrentRetailCleanPrice	PRIMEUNIT	AUCGUART	BYRNO	VNZIP1	VNST	VehBCost	WarrantyCost
0	1	12/7/2009	ADESA	2006	3	MAZDA	MAZDA3	i	4D SEDAN I	RED	AUTO	1.0	Alloy	89046	OTHER ASIAN	MEDIUM	OTHER	8155.0	9829.0	11636.0	13600.0	7451.0	8552.0	11597.0	12409.0	NaN	NaN	21973	33619	FL	7100.0	1113
1	2	12/7/2009	ADESA	2004	5	DODGE	1500 RAM PICKUP 2WD	ST	QUAD CAB 4.7L SLT	WHITE	AUTO	1.0	Alloy	93593	AMERICAN	LARGE TRUCK	CHRYSLER	6854.0	8383.0	10897.0	12572.0	7456.0	9222.0	11374.0	12791.0	NaN	NaN	19638	33619	FL	7600.0	1053
2	3	12/7/2009	ADESA	2005	4	DODGE	STRATUS V6	SXT	4D SEDAN SXT FFV	MAROON	AUTO	2.0	Covers	73807	AMERICAN	MEDIUM	CHRYSLER	3202.0	4760.0	6943.0	8457.0	4035.0	5557.0	7146.0	8702.0	NaN	NaN	19638	33619	FL	4900.0	1389
3	4	12/7/2009	ADESA	2004	5	DODGE	NEON	SXT	4D SEDAN	SILVER	AUTO	1.0	Alloy	65617	AMERICAN	COMPACT	CHRYSLER	1893.0	2675.0	4658.0	5690.0	1844.0	2646.0	4375.0	5518.0	NaN	NaN	19638	33619	FL	4100.0	630
4	5	12/7/2009	ADESA	2005	4	FORD	FOCUS	ZX3	2D COUPE ZX3	SILVER	MANUAL	2.0	Covers	69367	AMERICAN	COMPACT	FORD	3913.0	5054.0	7723.0	8707.0	3247.0	4384.0	6739.0	7911.0	NaN	NaN	19638	33619	FL	4000.0	1020
5	6	12/7/2009	ADESA	2004	5	MITSUBISHI	GALANT 4C	ES	4D SEDAN ES	WHITE	AUTO	2.0	Covers	81054	OTHER ASIAN	MEDIUM	OTHER	3901.0	4908.0	6706.0	8577.0	4709.0	5827.0	8149.0	9451.0	NaN	NaN	19638	33619	FL	5600.0	594
6	7	12/7/2009	ADESA	2004	5	KIA	SPECTRA	EX	4D SEDAN EX	BLACK	AUTO	2.0	Covers	65328	OTHER ASIAN	MEDIUM	OTHER	2966.0	4038.0	6240.0	8496.0	2980.0	4115.0	6230.0	8603.0	NaN	NaN	19638	33619	FL	4200.0	533
7	8	12/7/2009	ADESA	2005	4	FORD	TAURUS	SE	4D SEDAN SE	WHITE	AUTO	2.0	Covers	65805	AMERICAN	MEDIUM	FORD	3313.0	4342.0	6667.0	7707.0	3713.0	4578.0	6942.0	8242.0	NaN	NaN	19638	33619	FL	4500.0	825
8	9	12/7/2009	ADESA	2007	2	KIA	SPECTRA	EX	4D SEDAN EX	BLACK	AUTO	2.0	Covers	49921	OTHER ASIAN	MEDIUM	OTHER	6196.0	7274.0	9687.0	10624.0	6417.0	7371.0	9637.0	10778.0	NaN	NaN	21973	33619	FL	5600.0	482
9	10	12/7/2009	ADESA	2007	2	FORD	FIVE HUNDRED	SEL	4D SEDAN SEL	RED	AUTO	1.0	Alloy	84872	AMERICAN	LARGE	FORD	7845.0	9752.0	11734.0	13656.0	9167.0	10988.0	12580.0	14845.0	NaN	NaN	21973	33619	FL	7700.0	1633

Last rows

	RefId	IsBadBuy	PurchDate	Auction	VehYear	VehicleAge	Make	Model	Trim	SubModel	Color	Transmission	WheelTypeID	WheelType	VehOdo	Nationality	Size	TopThreeAmericanName	MMRAcquisitionAuctionAveragePrice	MMRAcquisitionAuctionCleanPrice	MMRAcquisitionRetailAveragePrice	MMRAcquisitonRetailCleanPrice	MMRCurrentAuctionAveragePrice	MMRCurrentAuctionCleanPrice	MMRCurrentRetailAveragePrice	MMRCurrentRetailCleanPrice	PRIMEUNIT	AUCGUART	BYRNO	VNZIP1	VNST	VehBCost	WarrantyCost
72973	73005	0	11/24/2009	ADESA	2006	3	CHRYSLER	300	Bas	4D SEDAN	GREEN	AUTO	2.0	Covers	68127	AMERICAN	SPECIALTY	CHRYSLER	8929.0	10605.0	10143.0	11953.0	8721.0	10295.0	12398.0	14231.0	NaN	NaN	18111	30212	GA	7600.0	1215
72974	73006	0	12/2/2009	ADESA	2002	7	DODGE	1500 RAM PICKUP 2WD	ST	QUAD CAB 4.7L SLT	GOLD	AUTO	1.0	Alloy	93744	AMERICAN	LARGE TRUCK	CHRYSLER	5485.0	6823.0	6424.0	7869.0	6201.0	7686.0	9169.0	10173.0	NaN	NaN	18111	30212	GA	7500.0	1353
72975	73007	0	12/2/2009	ADESA	2007	2	HYUNDAI	SONATA V6	Lim	4D SEDAN	SILVER	AUTO	1.0	Alloy	74407	OTHER ASIAN	MEDIUM	OTHER	7712.0	9614.0	8829.0	10883.0	7453.0	9004.0	11776.0	13041.0	NaN	NaN	18111	30212	GA	8000.0	803
72976	73008	0	12/2/2009	ADESA	2004	5	FORD	EXPLORER 2WD V6	XLS	4D SUV 4.0L FFV XLS	SILVER	AUTO	1.0	Alloy	82563	AMERICAN	MEDIUM SUV	FORD	4668.0	5714.0	5541.0	6671.0	6148.0	7521.0	9659.0	10944.0	NaN	NaN	18881	30212	GA	7000.0	1243
72977	73009	0	12/2/2009	ADESA	2006	3	KIA	SORENTO 2WD	EX	4D SPORT UTILITY EX	GOLD	AUTO	1.0	Alloy	65399	OTHER ASIAN	MEDIUM SUV	OTHER	7843.0	9171.0	8970.0	10405.0	7652.0	9310.0	12148.0	14204.0	NaN	NaN	18111	30212	GA	7900.0	1508
72978	73010	1	12/2/2009	ADESA	2001	8	MERCURY	SABLE	GS	4D SEDAN GS	BLACK	AUTO	1.0	Alloy	45234	AMERICAN	MEDIUM	FORD	1996.0	2993.0	2656.0	3732.0	2190.0	3055.0	4836.0	5937.0	NaN	NaN	18111	30212	GA	4200.0	993
72979	73011	0	12/2/2009	ADESA	2007	2	CHEVROLET	MALIBU 4C	LS	4D SEDAN LS	SILVER	AUTO	NaN	NaN	71759	AMERICAN	MEDIUM	GM	6418.0	7325.0	7431.0	8411.0	6785.0	8132.0	10151.0	11652.0	NaN	NaN	18881	30212	GA	6200.0	1038
72980	73012	0	12/2/2009	ADESA	2005	4	JEEP	GRAND CHEROKEE 2WD V	Lar	4D WAGON LAREDO	SILVER	AUTO	1.0	Alloy	88500	AMERICAN	MEDIUM SUV	CHRYSLER	8545.0	9959.0	9729.0	11256.0	8375.0	9802.0	11831.0	14402.0	NaN	NaN	18111	30212	GA	8200.0	1893
72981	73013	0	12/2/2009	ADESA	2006	3	CHEVROLET	IMPALA	LS	4D SEDAN LS	WHITE	AUTO	1.0	Alloy	79554	AMERICAN	LARGE	GM	6420.0	7604.0	7434.0	8712.0	6590.0	7684.0	10099.0	11228.0	NaN	NaN	18881	30212	GA	7000.0	1974
72982	73014	0	12/2/2009	ADESA	2006	3	MAZDA	MAZDA6	s	4D SEDAN S	SILVER	AUTO	1.0	Alloy	66855	OTHER ASIAN	MEDIUM	OTHER	7535.0	8771.0	8638.0	9973.0	7730.0	9102.0	11954.0	13246.0	NaN	NaN	18111	30212	GA	8000.0	1313

Overview

Variables

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Other Punctuation

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Pie chart

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Most occurring scripts

Most frequent character per script

Latin

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter

Decimal Number

Other Punctuation

Space Separator

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Uppercase Letter

Lowercase Letter